package com.yun.zf.admin.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.yun.zf.common.admin.model.house.es.RentEs;
import com.yun.zf.common.app.domain.ZfHouseInfoRent;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 * 租房维护表 Mapper 接口
 * </p>
 *
 * @author cj
 * @since 2021-03-09
 */
@Mapper
public interface ZfHouseInfoRentMapper extends BaseMapper<ZfHouseInfoRent> {

    @Select("<script>" +
            " SELECT  hr.lease_end,hr.lease_start ,hr.unit,hr.rent_type from zf_house_info_rent hr WHERE basic_id=#{houseId} and city_code=#{cityCode} and province_code=#{provCode} " +
            "</script>")
    RentEs rentToEs(Long houseId, Long provCode, Long cityCode);
}
